FILTER

Sweaters & Sweatshirts

Sort By

Items per page:

Essential Contrast Sweater

Essential Contrast Sweater TKEQ

query
	AMOUNT	FROM_PRICE	ROUNDING	TERM_SALE_ID	TYP

SELECT b.typ,b.amount,a.term_sale_id, b.from_price , b.rounding FROM tb_term_sale_entries b LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id) LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id) WHERE b.start_date<= '2026-01-22 13:30:00' AND b.end_date >= '2026-01-22 13:30:00' and (b.store_id=1) and b.style_id=197442 and a.approved='Y' ORDER BY a.term_sale_id desc

query
	AMOUNT	FROM_PRICE	ROUNDING	TERM_SALE_ID	TYP

SELECT b.typ,b.amount,a.term_sale_id, b.from_price , b.rounding FROM tb_term_sale_entries b LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id) LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id) WHERE b.start_date<= '2026-01-22 13:30:00' AND b.end_date >= '2026-01-22 13:30:00' and (b.store_id=1) and b.style_id=197442 and a.approved='Y' ORDER BY a.term_sale_id desc

Sailor Blue with Black

Sailor Blue with Black "Equestrian" Crewneck Sweater KASTEL DENMARK

query
	AMOUNT	FROM_PRICE	ROUNDING	TERM_SALE_ID	TYP

SELECT b.typ,b.amount,a.term_sale_id, b.from_price , b.rounding FROM tb_term_sale_entries b LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id) LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id) WHERE b.start_date<= '2026-01-22 13:30:00' AND b.end_date >= '2026-01-22 13:30:00' and (b.store_id=1) and b.style_id=197336 and a.approved='Y' ORDER BY a.term_sale_id desc

query
	AMOUNT	FROM_PRICE	ROUNDING	TERM_SALE_ID	TYP

SELECT b.typ,b.amount,a.term_sale_id, b.from_price , b.rounding FROM tb_term_sale_entries b LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id) LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id) WHERE b.start_date<= '2026-01-22 13:30:00' AND b.end_date >= '2026-01-22 13:30:00' and (b.store_id=1) and b.style_id=197336 and a.approved='Y' ORDER BY a.term_sale_id desc

Crewneck

Crewneck "Jump" Sweater KASTEL DENMARK

query
	AMOUNT	FROM_PRICE	ROUNDING	TERM_SALE_ID	TYP

SELECT b.typ,b.amount,a.term_sale_id, b.from_price , b.rounding FROM tb_term_sale_entries b LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id) LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id) WHERE b.start_date<= '2026-01-22 13:30:00' AND b.end_date >= '2026-01-22 13:30:00' and (b.store_id=1) and b.style_id=190121 and a.approved='Y' ORDER BY a.term_sale_id desc

query
	AMOUNT	FROM_PRICE	ROUNDING	TERM_SALE_ID	TYP

SELECT b.typ,b.amount,a.term_sale_id, b.from_price , b.rounding FROM tb_term_sale_entries b LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id) LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id) WHERE b.start_date<= '2026-01-22 13:30:00' AND b.end_date >= '2026-01-22 13:30:00' and (b.store_id=1) and b.style_id=190121 and a.approved='Y' ORDER BY a.term_sale_id desc

Sort By

Items per page: